SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001304s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 435904 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 435904 [ RunTime:0.002998s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (483643,351408,485129,845189,578097,338882,828362,142752,425535,609018,316438,132572,961444,238596,827958,673191,82974,286758,152858,409918,376660,557291,100318,380419,197252,510107,595934,226519,904437,509161,7890,75806,691219,859404,928135,922246,875781,544395,460590,523681,261094,451713,45794,537178,145762,130090,876485,364571,881417,1036139,517393,349011,650421,892371,392705,521640,331536,22571,334582,156202) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001042s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 435904 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 435904 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]