SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 801219 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 801219 [ RunTime:0.002139s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (967573,502097,955323,767348,727999,558402,86029,362683,249981,743049,992995,265786,711056,269292,162225,436265,106801,496721,921029,904432,648837,88126,145480,496740,340454,968517,784901,406896,102861,398326,815742,387443,553223,862250,738691,1041812,1025867,220481,393487,963347,142171,325521,111520,545559,259876,1036939,220088,542963,410119,715679,183884,156842,790471,1016238,455612,1034231,474388,865824,639854,637417) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 801219 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 801219 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]