SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 430 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 430 [ RunTime:0.001489s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (382252,968212,154391,726478,882511,295331,77982,626898,277871,703298,891323,423049,884415,238177,21423,227753,515040,383149,349351,664108,401216,79422,428103,613833,22874,3839,80078,493792,408632,477868,1011190,132647,401431,815684,95377,253852,518293,589482,828414,273648,350399,187853,164472,87555,813769,540311,896102,454592,977645,965303,396897,629563,453971,485174,341772,770547,762329,693082,332348,700498) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000958s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 430 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 430 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]