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` = 40342 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40342 [ RunTime:0.001730s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (592010,398444,9491,873324,922773,417515,980638,1024668,1017778,105709,673863,471844,838103,522141,636590,914586,11396,225151,582780,606365,85233,676681,478096,800821,576002,782957,783890,112767,603253,85121,215160,507924,691670,854879,630760,560653,193175,531130,580888,612290,534607,132780,895495,349284,373610,550824,818590,569530,677410,372614,397572,393083,488537,453442,969410,687101,588175,858830,44456,562339) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40342 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000684s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40342 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000676s ]