SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 919838 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 919838 [ RunTime:0.001634s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (401966,884353,19752,205289,369121,336887,88470,536600,747899,392680,491538,894883,434772,801588,169605,745625,501306,333062,633194,111602,734366,533140,105877,548046,699721,265241,766573,771503,723325,319356,438845,476518,16185,518487,70090,654853,334935,407550,210689,104546,165607,466369,412329,557510,1723,201298,76775,880953,74105,1017234,276520,1016150,95593,54430,207566,980723,584477,343187,765131,516680) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 919838 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 919838 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000465s ]