SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 408118 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 408118 [ RunTime:0.002271s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (913815,243771,20971,408657,257147,736193,471547,325128,135829,999630,768906,736187,967320,204511,159598,180054,1003684,1010364,63464,378982,48035,29436,73641,99365,382522,16482,255548,298846,590265,668476,183134,799602,257302,830582,2690,538535,517776,75114,528469,355482,153141,169794,554272,827804,584180,957479,1038026,792497,78627,802886,569649,691247,686544,650582,496889,937885,640074,175900,479471,268721) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 408118 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000760s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 408118 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000957s ]