SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 172612 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 172612 [ RunTime:0.001640s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (53643,732415,1008176,818990,776318,223199,1009255,809138,420354,378740,1030007,986771,337971,907368,1029791,123707,673369,934960,609220,81520,372247,170442,974201,880258,107400,881426,572387,141001,788242,891796,697710,151887,378895,599619,1026200,246358,923419,157176,709394,216688,795589,660549,731203,197211,503559,596022,825420,1047057,190461,57641,590598,809744,22591,894189,177140,937838,337023,376368,341284,250423) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001061s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 172612 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 172612 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]