SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 804188 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 804188 [ RunTime:0.002641s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (144826,717176,536980,613492,439010,258398,326308,23416,362559,116806,380542,122915,833477,680710,67603,604529,624505,206407,282395,374090,96760,277974,805480,602825,180855,905712,1002635,597280,413185,214824,699960,818879,170651,661483,932513,838191,349055,561449,919825,267058,316902,105288,789474,332930,416325,753754,938827,325847,242581,15089,910073,788826,533255,193832,687985,689261,438887,796672,613564,964132) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001328s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 804188 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 804188 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]