SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 339311 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 339311 [ RunTime:0.001592s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (504742,579369,978582,696569,182651,572412,33581,198688,966489,208740,421643,821038,164248,907277,885287,10960,431620,764227,51180,887579,869320,699472,230182,983645,797968,655277,106303,137173,444931,209738,218341,156735,986118,368189,607615,137044,1033427,703643,576562,246582,763002,933869,366289,108203,342114,546518,1015854,312182,997841,1043477,324688,925946,272408,429311,830344,443909,880601,862784,237035,396878) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001555s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 339311 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000486s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 339311 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000470s ]