SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 314550 LIMIT 1 [ RunTime:0.000424s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 314550 [ RunTime:0.002002s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (329246,741370,73539,922999,152162,924193,760566,28904,548869,334741,181558,357689,690078,572299,474247,994878,850643,929633,901092,437718,512486,861899,28471,383767,645096,21314,435149,675951,622176,156025,77076,118408,728552,547100,956718,686560,598645,327874,292051,997593,5983,242632,965109,779541,273101,617188,442006,979488,762872,554780,449806,642229,250424,54306,204172,553180,207093,827107,1036555,631748) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003062s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 314550 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000457s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 314550 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000820s ]