SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001101s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010947 LIMIT 1 [ RunTime:0.001872s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010947 [ RunTime:0.001665s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (289270,150359,211941,276703,1031881,892994,987843,168730,240728,362376,525154,474247,84970,521228,846552,893656,973254,429527,1022304,1012835,1030417,815674,944513,974631,1048837,451156,374028,138982,942522,986151,928834,28837,89637,170679,835308,772647,123714,976082,246318,192436,880793,377212,817564,873557,312002,356672,570844,917614,550391,886123,202237,871471,5097,24556,463642,14982,461690,968888,666348,370985) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003331s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010947 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003001s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010947 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003722s ]