SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001987s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 418527 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 418527 [ RunTime:0.002126s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (91359,693030,702461,77598,622313,211124,1014298,250253,790938,860477,90395,291784,817712,984166,609764,332036,691027,86688,27090,186542,591338,389682,413329,954166,95620,412666,603999,101051,159165,231383,266890,148399,219850,574203,338845,570006,239280,947626,673006,345573,309016,796522,962682,63474,497439,353878,607403,435127,986254,412431,570808,268781,767868,123751,852891,238684,133583,90831,485234,714795) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 418527 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001705s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 418527 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000528s ]