SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 199018 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 199018 [ RunTime:0.001833s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (355879,855522,369133,496057,877572,708735,698855,255013,525497,772918,381438,1012741,812648,67141,651102,23212,260176,348286,642756,268585,48680,554587,811144,883482,572201,611543,923371,146736,203172,973160,418696,828306,5170,134550,478592,109790,902252,965201,742030,447030,619666,869805,7797,330306,955992,1038552,642728,64438,469726,338625,115495,889032,618644,1036327,525021,591914,216607,348343,1031810,819325) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 199018 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 199018 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]