SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 523819 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 523819 [ RunTime:0.002002s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (831299,541121,562790,129658,247901,32357,571442,352491,287493,477365,282235,124202,989992,976255,459392,62729,69847,542926,231451,599300,59854,401153,459628,87759,560305,326522,983816,239908,873211,1007157,69495,1027218,131054,100244,261016,786630,561202,389833,963761,699871,71889,441464,407800,356767,661777,855282,830778,213895,344088,394088,98238,92759,344762,874821,1043790,736347,525197,683289,612596,881561) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000974s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 523819 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 523819 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000626s ]