SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001544s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 336813 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 336813 [ RunTime:0.001780s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1034986,872888,863663,545816,535251,633104,703543,287308,894700,344802,102537,452410,533136,155624,903074,801751,81742,81526,749060,127949,128694,67978,657625,277574,624399,381734,630261,725921,371031,341240,544293,500829,728737,11282,637798,530609,391221,650277,368242,510463,754297,697963,707585,1003282,293043,339658,524188,541926,552013,41231,895267,509706,630009,407698,337284,1044399,154060,982312,847122,374180) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 336813 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 336813 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000759s ]