SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 556791 LIMIT 1 [ RunTime:0.005219s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 556791 [ RunTime:0.007738s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (451588,240630,397049,825272,905115,695543,166624,327511,882428,607166,719766,358552,925660,473295,252482,905690,674421,955528,277911,168829,51912,975465,25517,1041865,289276,262623,837520,34953,568691,176985,836970,856530,344352,921423,127334,891706,253352,3949,948413,137958,9689,798756,509609,736469,109086,262591,571609,534133,565714,839216,899522,810524,849416,449170,430340,698115,794230,929097,881223,799765) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003452s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 556791 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 556791 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000633s ]