SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001504s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 391912 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 391912 [ RunTime:0.001720s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (232794,72210,44762,667167,785949,1006311,792794,441656,765746,762045,576191,69129,40305,361141,888207,34896,211914,261312,628100,461706,44974,840079,912842,839101,1011568,640512,623566,535715,780901,854684,494194,265989,82886,691552,161614,99318,406428,416920,638063,429537,1041443,279128,312184,862240,669067,634853,308998,404580,756836,350332,554650,728269,568508,323285,126637,41899,344926,725154,772140,41667) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 391912 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000579s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 391912 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000646s ]