SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001923s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1018189 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1018189 [ RunTime:0.001640s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (631962,300973,174632,713244,173439,1024987,278654,121770,169346,656009,934918,820898,559931,549129,344412,163882,773504,384299,733200,231351,120987,537117,762741,823988,384128,648285,996024,244818,671994,131156,149112,388247,445359,320484,393896,1044816,219341,58106,391470,765624,957422,178271,646897,312529,984871,537254,107022,284288,287438,990947,575257,717993,1007534,545858,698393,395030,736153,193082,410357,1006906) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000973s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1018189 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1018189 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]