SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001523s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 314086 LIMIT 1 [ RunTime:0.000459s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 314086 [ RunTime:0.007380s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (905951,550347,198882,850784,941935,499131,141693,445344,588982,669143,296955,624878,241205,106821,10393,378504,790202,594695,345334,1013640,281024,149217,72821,917855,248331,359177,158191,224379,264529,524243,665698,886964,997695,953448,374750,857123,764594,1000184,543407,512771,584267,1017951,467357,295228,1020690,891038,949175,504409,919110,230297,596247,424377,155161,188022,659274,479323,473750,499516,399888,485559) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 314086 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 314086 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000485s ]