SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001331s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 485891 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 485891 [ RunTime:0.002332s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (893053,69848,83848,728998,151480,1942,254931,111836,1035770,618144,795661,585688,520689,840278,606685,283439,261994,948608,930825,490514,791548,992184,233843,157055,274884,392667,841798,809659,99268,419477,193208,347288,451657,1017340,601422,462652,524837,828192,129053,779529,993854,227194,1010231,356044,216889,27999,726685,796369,171750,631156,508765,705175,841887,1042689,26128,1031715,116249,164082,716207,590468) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001706s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 485891 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 485891 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000521s ]