SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1036727 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1036727 [ RunTime:0.001754s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (722651,620512,720129,635929,261304,878396,251177,175078,552122,458067,954197,965561,868698,676780,335891,2834,828034,310415,173614,61997,553182,606852,588928,491834,217437,917913,936815,480016,430660,55853,18881,204454,465932,919797,756907,801660,747454,194387,565156,332911,5224,108608,396527,520966,900195,536940,307011,124491,715484,788398,955758,143945,261903,426368,484113,626204,506306,319242,971082,132887) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1036727 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1036727 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]