SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511294 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511294 [ RunTime:0.001937s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1032837,621658,346481,967161,514616,384958,246797,959611,645023,134612,162118,397527,343643,571983,172089,522249,773513,86035,431970,772813,601327,960077,26119,1015213,110976,940482,740518,342716,707180,482229,521808,795488,781150,21201,479009,949849,62621,770032,305023,378813,558240,712792,652886,298188,896236,184173,962367,638929,447566,579033,892707,569476,704666,748545,157548,200355,246748,36489,809636,225844) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001276s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511294 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511294 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000418s ]