SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 334800 LIMIT 1 [ RunTime:0.000417s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 334800 [ RunTime:0.002349s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (109701,819242,808686,620263,349438,370412,402474,425950,206431,879147,457596,478212,1030792,1014415,1044910,476522,893325,899583,1045999,424881,172897,158657,651209,747603,779938,489697,353338,1039963,523336,849490,745272,869198,188347,90979,745738,457754,974459,108958,667400,226382,903464,609957,478352,66989,835981,762109,879702,514946,687950,538653,725890,332218,246273,264364,663609,470324,602353,751492,849379,529616) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000973s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 334800 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 334800 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]