SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 563280 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 563280 [ RunTime:0.001583s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (366506,1007271,520522,651362,427334,360583,807530,890471,226423,443507,58762,25270,182730,659774,152936,386838,826203,715646,84715,910332,55683,344241,634871,236900,617174,219735,126807,613785,952203,197664,1043317,714150,696578,700816,113648,424168,66299,236888,290395,163679,415820,408074,326864,1043221,335702,704144,311079,175004,86842,107165,487898,153656,422051,625400,233070,530441,686247,24947,733159,266053) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002512s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 563280 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 563280 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000365s ]