SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001317s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1000994 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1000994 [ RunTime:0.003586s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1029890,528795,705912,916606,172779,921405,245244,178374,229387,417185,152512,741746,1035729,419743,655817,101240,594670,163335,1044986,838659,677124,199148,150187,552605,510925,995360,627762,987086,91349,891193,594262,903241,878176,813502,299777,752487,848874,64939,701259,554268,2073,238447,671520,264377,551668,126675,645598,703825,43462,220246,176852,462285,760968,576021,159136,155724,123778,724889,796257,880417) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1000994 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1000994 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]