SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001272s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 340523 LIMIT 1 [ RunTime:0.000420s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 340523 [ RunTime:0.004724s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (631806,387981,580355,950372,801116,499960,956544,475302,386942,881839,996251,869399,100022,504005,464409,1164,317348,266740,398914,549613,694367,427217,713939,211485,239144,937506,227204,642200,207946,289729,430545,770389,568967,333076,658826,598780,797704,145434,79407,158082,268873,419387,43549,179150,809778,362169,1005435,770333,700548,238020,14951,215927,804512,903834,893865,112009,543297,110324,885158,776719) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 340523 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000483s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 340523 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000499s ]