SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001342s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 513505 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 513505 [ RunTime:0.008195s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (865141,220087,424337,140341,608091,556073,122471,774643,307950,120357,512010,328169,304519,84460,547810,258356,279631,696835,385709,580047,747066,457343,183840,1038420,901752,640241,347070,848563,483034,179541,649062,284851,541435,136983,307603,784764,228427,183961,235104,39147,41940,801399,34040,388050,272807,287618,774264,625555,60347,322878,774309,79467,845777,586703,818372,355653,977236,792692,466009,944977) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004185s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 513505 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000490s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 513505 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]