SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 591994 LIMIT 1 [ RunTime:0.001072s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 591994 [ RunTime:0.001635s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (6700,313258,296482,668971,725851,746063,543410,662939,150030,229952,288346,213054,228199,1006600,915789,319962,105358,105492,576988,620987,502828,643993,880667,514419,199808,482630,581870,146596,53880,611274,113134,22707,1016670,984434,584637,703911,814261,903021,1017754,195974,116824,659953,857980,653022,202834,858125,461316,939451,422490,755880,201021,956820,196944,950342,305997,911340,598424,444746,112652,189708) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002210s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 591994 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 591994 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]