SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001447s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 105102 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 105102 [ RunTime:0.003708s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (999723,433057,168101,34599,301753,841692,478244,466787,562769,1038569,144346,790606,976111,925767,979144,52488,115406,256618,403273,975028,392055,446911,90234,323608,778559,616228,479746,11933,468670,148623,294309,288413,359153,732289,1027859,187247,744583,501496,96190,455793,814905,118300,706838,11541,360433,720056,528197,477390,639907,197591,575196,1022230,398086,706987,245829,975890,466626,236921,89187,791557) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 105102 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 105102 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000635s ]