SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001724s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 476013 LIMIT 1 [ RunTime:0.000591s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 476013 [ RunTime:0.001734s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (257196,24573,1044708,261012,981816,224825,865811,373094,95825,8635,110215,74716,241641,326880,1014153,846585,382484,759695,468391,937455,1031327,654969,348910,490277,12658,621113,692910,554445,696295,245820,756372,840559,578814,590930,815385,178585,799734,990268,940914,675578,145211,999339,1017161,298167,813058,219039,41378,614324,782361,196098,223780,177477,912808,798352,465231,85913,172117,628364,406751,49955) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 476013 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000554s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 476013 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000946s ]