SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040942 LIMIT 1 [ RunTime:0.000418s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040942 [ RunTime:0.003154s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (889188,133456,1048025,501696,919494,548815,117169,458796,668480,474452,797236,511196,428913,120161,108901,303520,283123,725718,389679,379590,781258,813167,358958,200330,12557,90742,458902,656702,189500,698713,91284,513165,252654,206693,966435,156718,528991,281549,474900,514295,499273,58741,383796,68117,526136,332148,265047,689479,310001,779654,451521,337904,820777,87384,100406,129470,234110,301643,582833,636702) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040942 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000466s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040942 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000631s ]