SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001312s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 518023 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 518023 [ RunTime:0.003481s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (23486,741313,205059,917174,904480,117582,908341,654021,1042533,746097,581991,62875,168985,784874,218867,648701,590073,314516,62478,212112,161424,385376,490703,365200,359584,269749,902164,268503,579908,301591,5263,673859,199358,33516,782952,874498,403571,131678,1035119,215605,530324,418619,584861,325842,560917,874872,697586,83911,822888,510960,560015,327160,907458,216410,235050,721469,1048455,740573,713178,558548) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001037s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 518023 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 518023 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000406s ]