SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001454s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 429967 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 429967 [ RunTime:0.001976s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1042304,371720,899071,911456,1022203,734922,358130,400572,921932,1039945,633047,974337,965943,864136,787741,370179,97497,99082,447594,358386,694124,592125,60049,752741,225458,723346,704909,132589,455633,477465,890495,435264,258067,265461,830268,260336,751675,872238,699113,607119,26895,1004220,896135,1002504,998423,751273,625078,125121,889383,450646,193772,640423,62255,984162,1027383,728713,228740,187059,95512,868318) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001475s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 429967 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000544s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 429967 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001223s ]