SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 102920 LIMIT 1 [ RunTime:0.000420s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 102920 [ RunTime:0.002451s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (543843,558525,274673,438478,74680,832451,791372,761135,500144,287384,221576,629825,518080,205786,867022,56654,489590,85004,223364,172740,66550,669693,59635,785233,157076,610557,206646,750089,693881,27490,159660,218576,718022,251574,191860,535212,287509,347844,628223,160498,204215,330027,181539,659800,769317,154199,891367,390186,103826,258543,394682,393001,142973,1046116,790657,308337,146284,827874,518537,395610) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001238s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 102920 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 102920 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001334s ]