SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001363s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101544 LIMIT 1 [ RunTime:0.000652s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101544 [ RunTime:0.002094s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (619088,484136,57955,223810,717100,145508,349393,675175,636641,544602,283401,949171,256028,394255,658671,742233,632074,838396,20906,862907,914805,511045,23234,696807,485041,388339,781182,699732,116943,244746,712707,441203,296940,321507,576989,61371,464281,645416,389659,929257,814111,122753,993435,481741,806553,317686,242155,282939,450601,422975,578065,654672,648028,869185,548000,885267,149621,312735,107135,572512) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001074s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101544 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101544 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]