SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 463518 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 463518 [ RunTime:0.001758s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (975611,440848,979864,938706,506135,737200,539832,168198,898252,265376,20044,517889,868007,504794,975169,137523,353109,219140,980558,102469,176500,901869,279628,435331,642519,309388,782717,748866,325457,416236,144972,792708,521227,220343,1028512,969674,438157,241721,529673,986092,184504,319656,471310,919836,355939,986899,726824,342415,690012,410188,81390,294256,181809,218237,1046114,393875,414413,575721,179918,38055) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 463518 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000502s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 463518 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001234s ]