SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001330s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 333238 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 333238 [ RunTime:0.002404s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (10073,437640,288783,130657,463371,414037,763927,339925,939290,948888,254371,1008690,108651,22499,896870,460549,689371,873313,952771,310202,213961,747388,657007,208177,999797,225796,362495,816778,540183,637065,275053,998345,284726,380717,104162,290122,518247,4424,874626,210621,521779,793047,318002,779050,559392,329195,337900,992510,248470,190667,24594,410410,165402,190074,538282,372017,725640,736902,483469,393149) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001055s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 333238 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 333238 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]