SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541087 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541087 [ RunTime:0.001677s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1003229,607894,25686,951042,324498,872898,180385,564506,871689,535971,869056,688850,883070,174372,239521,59599,82546,144535,153868,46364,865268,790694,332667,830189,930714,75939,884156,780831,145202,591873,575983,415149,255465,520160,97836,177683,531045,270364,1045354,651080,70380,1005213,768789,821501,452897,488661,769593,166881,310102,254842,286808,176463,307206,372703,477745,174332,448392,351390,583933,790886) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000987s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541087 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000316s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541087 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000467s ]