SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 338504 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 338504 [ RunTime:0.001827s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (830051,429015,956296,338172,303510,320503,778154,1047496,155453,177740,805722,719929,609819,373485,1042230,592027,961498,395533,472617,615903,1039241,319983,680512,755159,485557,76074,107118,210892,871981,1019650,511197,366463,224066,746252,419071,946772,144009,761805,418249,543040,611946,680051,880802,66693,944886,925614,318791,49620,508299,23146,1031468,628812,822292,993181,20624,697322,751684,111992,979366,830478) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001053s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 338504 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 338504 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]