SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 404775 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404775 [ RunTime:0.001543s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (770270,851806,312040,308280,833102,947841,972972,699997,481253,1006084,54536,337972,263141,218198,475065,411737,681702,268591,495803,596621,775923,579318,893877,36182,1015822,633412,255982,444935,19713,136777,701218,242393,494703,266863,337243,122297,429482,49998,231518,411995,532639,875586,700861,48488,337047,288842,919501,161215,256765,180130,578123,646756,871670,1042044,1002260,698977,1018070,745053,865965,1004503) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001006s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404775 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404775 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000475s ]