SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 521800 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 521800 [ RunTime:0.001522s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1008598,928911,694506,672925,710642,145182,132570,280011,830924,278052,607944,458993,913799,640622,617293,478947,836630,458637,286907,796944,114731,534532,6737,444927,418864,691264,495978,257221,821391,184051,827104,427081,717668,585179,1008996,362277,162624,1016423,272487,664637,268747,913189,441170,879123,304642,830372,638486,628795,299800,923326,382094,523328,709417,284612,305192,605133,976187,283828,375793,830752) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 521800 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 521800 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]