SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001509s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 423144 LIMIT 1 [ RunTime:0.000444s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 423144 [ RunTime:0.003144s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (393969,938708,1042791,676570,530506,794439,680366,684732,648950,687870,346503,24733,272067,179630,921270,378985,831874,1036884,453250,739670,252542,139551,1030378,433910,458192,115697,934141,1020189,220799,749605,893581,558697,525241,227831,378134,574914,814643,849183,29248,194884,750720,789350,298292,331547,167493,718370,548805,293240,613018,356711,95330,469326,34185,290192,838811,586184,453636,73188,2433,411238) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002192s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 423144 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000517s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 423144 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000791s ]