SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1009626 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1009626 [ RunTime:0.001923s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (432785,969613,681042,977386,899065,212986,2093,68598,997284,557536,712685,101621,92754,343204,351980,543571,750664,264468,651964,717410,243030,129870,227248,476554,1006821,1047613,709899,157902,860254,949893,127594,663070,1038389,647846,448837,801827,593905,1018324,380304,815439,379946,459604,838154,729081,580089,891965,223198,575737,825748,630781,990117,276870,419877,1028290,310414,820762,612699,983238,804968,535519) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000946s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1009626 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1009626 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000460s ]