SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001046s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1006341 LIMIT 1 [ RunTime:0.000674s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1006341 [ RunTime:0.002555s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (369120,571253,71358,747509,139102,213188,872550,852930,961309,511154,594409,48612,495145,114306,597866,609962,774822,699096,361063,378189,399494,769229,970273,281957,192162,357223,904794,514742,40430,810249,982324,279480,798337,878670,470358,255393,890692,572151,721804,474540,944773,247216,393385,492814,748097,315440,726952,248628,891892,402229,63756,103559,494926,860415,637463,402365,391306,869066,1026986,63604) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001530s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1006341 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000698s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1006341 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]