SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 472308 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 472308 [ RunTime:0.001473s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (424796,372722,96448,690368,115838,165436,628316,750614,783401,534825,472640,519419,251089,277803,387154,579243,341620,248237,416255,937599,1022058,378716,589149,505962,1042441,363734,526581,561485,909282,98412,256115,752280,51735,804138,16978,1042077,362452,455358,729802,747287,96039,127284,112846,185017,832924,59680,698443,506330,114499,324884,526673,364884,558772,597554,9454,260479,333952,318555,455080,76114) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001022s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 472308 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 472308 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000589s ]