SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001363s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416144 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416144 [ RunTime:0.001621s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (364036,110287,709556,132455,73804,982006,760025,286854,20327,1024240,520871,196900,482262,140920,261704,902707,445095,7102,855010,1045231,908733,262867,520710,889499,676749,740296,238026,1045802,111627,969445,159613,309575,267209,449614,802717,134494,108968,137256,269184,860503,950155,603954,602364,894962,814672,390968,782476,84877,255935,523948,393362,959534,679184,432896,485758,537164,712122,307818,393166,779928) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001276s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416144 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416144 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000728s ]