SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402717 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402717 [ RunTime:0.002878s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (806445,294216,698265,574229,171209,874909,927613,432680,495308,239125,16619,124474,100013,554707,234372,556102,378470,776152,101026,45829,812769,600171,68927,5401,106561,425351,178327,314572,364840,1029693,215233,5507,362214,471621,997164,990679,377927,326937,895772,176838,687161,837133,223110,1025076,289669,164294,81350,790012,73926,4732,880656,363945,352369,1016484,501220,121341,58998,61601,1000061,864957) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001059s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402717 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402717 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000536s ]