SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001500s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017072 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017072 [ RunTime:0.001784s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (681392,617071,247794,545487,719277,111366,817000,834936,402120,417785,338801,289420,310331,712229,747064,236231,329047,569421,861953,82612,204645,52552,412778,7194,137667,465166,811618,488017,219184,609834,166266,857331,727524,728597,673833,171736,975217,380390,335194,315287,268564,927739,131169,365640,377246,263331,309435,180773,901959,489377,176670,358187,415924,106291,1021769,840387,962060,794206,118377,506032) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017072 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017072 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000434s ]