SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002060s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040008 LIMIT 1 [ RunTime:0.000290s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040008 [ RunTime:0.001721s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (585829,731717,774071,570897,556210,13859,162552,461075,1019855,669809,939294,797308,959307,464154,739564,444022,843653,97502,857497,613776,475167,15067,166629,398527,201090,267292,378729,424147,349069,772178,729592,326368,18066,114218,1019640,197094,1009655,359276,776070,432749,222010,24842,964904,132417,535134,811618,1029752,1031004,297724,477138,330510,975290,739081,873258,1029928,376446,499574,245679,133831,764785) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003264s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040008 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040008 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]