SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 427001 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 427001 [ RunTime:0.001655s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (794350,676268,868059,917605,41059,1010145,2710,154404,860064,369456,960961,264798,442632,509175,877510,323208,500009,929790,440019,886074,578751,107678,867961,718594,189173,308655,238003,19345,1027306,779968,270094,505843,1047413,476513,92009,800662,183001,744218,552771,936834,437733,814729,64937,847262,9280,985963,753394,404465,892118,145388,378032,870217,630970,270204,923456,582177,68238,608050,782889,983706) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 427001 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 427001 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]