SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410991 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410991 [ RunTime:0.001653s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (60039,292294,853466,686736,879769,394614,71058,478942,577708,148611,497865,490380,614839,926978,549708,454029,223010,773086,407754,461586,780899,849866,363561,80264,210180,128346,574405,361667,654977,1012017,824733,562952,530266,380675,258611,837543,66544,280874,536666,970084,439365,464173,171506,304994,744202,755215,43370,100314,352886,730819,254819,601438,646836,107793,853403,829510,468090,61926,486778,200857) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410991 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410991 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000639s ]