SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 855611 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 855611 [ RunTime:0.009214s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (561056,127147,228060,294124,76337,217283,778216,587857,573533,809712,105773,198081,852198,978654,108238,430606,151552,209002,393211,633592,781684,1008626,102909,353333,322218,828557,661242,48144,668549,733117,915689,223165,362356,828982,980499,759276,257830,471058,654233,24323,974989,338170,449548,452261,25636,995596,342536,932338,833477,218188,323786,652859,892023,499151,379320,476422,729059,622672,936140,118791) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 855611 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 855611 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001276s ]