SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 143178 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 143178 [ RunTime:0.001830s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (552117,498947,896221,916474,331669,796094,878404,575484,989230,144753,1012054,317036,988832,576185,920522,236547,156912,509443,861393,135524,174545,838717,564102,990466,1040592,173341,859529,45546,784469,458941,1012344,1020011,1032459,557731,272805,78518,1007385,746704,629079,173889,88419,30525,990011,183810,14227,377900,420398,58089,276400,919073,15566,993565,155318,533985,825425,180540,878351,221586,820622,807040) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001017s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 143178 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000325s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 143178 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000474s ]