SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1001896 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1001896 [ RunTime:0.001742s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (700487,381260,745531,405300,229582,1038472,416269,614161,440761,979441,456832,863858,889436,759249,480371,471856,742339,409108,643351,940498,65793,622860,465058,391944,942687,984750,1001792,253610,169379,493944,537938,109368,696104,193507,324201,402238,648708,1033052,781514,851298,271768,811835,288201,266938,724040,158199,144874,585148,922684,225103,543114,72463,7849,161331,1006421,698564,861416,868681,478239,102383) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1001896 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1001896 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]