SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001241s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 582048 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 582048 [ RunTime:0.002125s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (645611,840746,259360,140619,1004927,689366,648625,906646,485334,489855,936871,754754,1031686,771929,62590,306898,101563,820631,646513,1012800,499737,337899,650902,847564,559264,115010,153298,844202,812140,367099,116216,366493,89617,458732,84996,210890,814733,933722,86565,462706,96444,13889,1039414,908928,420886,931139,234884,766544,355359,791614,80029,792960,4997,544674,1019747,789600,942711,407819,191719,759655) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001074s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 582048 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 582048 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000448s ]