SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002071s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 473750 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 473750 [ RunTime:0.002458s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (369375,55856,1025401,823933,1043511,327199,561389,575175,41813,229541,149486,1039086,324785,991143,856660,1002954,931043,559565,331439,890857,867566,49299,389888,705047,929608,334208,274543,947123,747642,1029507,943673,279989,244678,1047674,554878,10256,536450,721611,333738,176790,777043,38495,890523,616086,43134,931687,535322,118860,635689,510838,693159,412916,1040674,146987,380698,132852,1028857,108524,846436,963144) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001025s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 473750 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 473750 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000433s ]