SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001437s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 400375 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 400375 [ RunTime:0.001545s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (505403,1018305,505252,589252,116911,590308,990307,611919,724633,728545,273461,359644,1021047,511782,739409,625173,734787,841917,977794,706389,674597,351578,409598,913709,73079,1024178,394351,504437,450788,336224,499318,311528,791420,598464,286342,482543,827396,699428,874823,881399,263333,403880,80492,335640,267369,280237,53316,303192,469311,239287,227415,273557,630051,761113,893254,663164,431978,479711,596677,704998) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001283s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 400375 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000496s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 400375 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]