SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001251s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413100 LIMIT 1 [ RunTime:0.000289s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413100 [ RunTime:0.002845s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (297066,586069,935667,436172,164696,828068,967312,360917,736813,817803,870202,953336,417477,835733,554404,479263,293481,594756,1711,782030,224182,729532,489423,259948,919405,863193,291102,492515,543208,448252,461329,880393,729779,681395,103853,935232,19370,275336,108070,847340,171010,350869,275437,119289,119514,830715,24223,783830,122652,136783,400360,117223,569658,649290,199330,34492,597876,413117,784025,805493) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001023s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413100 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413100 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]