SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 123910 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 123910 [ RunTime:0.001962s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (571711,102705,541808,504257,57112,157975,540932,330430,120390,862295,1037253,690517,397644,775321,708888,322527,212000,363488,164911,178638,9204,427189,294942,115332,333980,657015,102552,427590,275724,189537,75997,155321,544576,977630,1006978,83995,217623,919619,142972,822907,142647,459621,416591,375224,336964,349628,467904,107846,270539,284862,435666,178485,1030633,352184,906982,549843,49741,173673,660485,580922) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001059s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 123910 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 123910 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000412s ]