SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001493s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 328551 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 328551 [ RunTime:0.002028s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (425371,993917,329066,961364,78979,347873,425412,299436,426556,564542,675094,1045530,815781,45064,408160,716474,623699,1003762,664661,642381,234819,456721,412767,214875,873472,616859,981409,151798,419304,133809,462402,106191,1027491,488810,666186,592651,882888,109812,857230,62675,198960,799998,381900,998505,720463,955600,441910,239526,30785,394328,338320,984301,566487,140996,778047,205936,470133,834615,180639,385069) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 328551 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 328551 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000727s ]